-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 17, 2013 at 07:20 AM
-- Server version: 5.0.77
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `local_codeigniter_base`
--

-- --------------------------------------------------------

--
-- Table structure for table `sm_module`
--

CREATE TABLE IF NOT EXISTS `sm_module` (
  `module_id` int(11) NOT NULL auto_increment,
  `module_name` varchar(250) character set utf8 NOT NULL,
  `controller_action` mediumtext character set utf8 NOT NULL,
  PRIMARY KEY  (`module_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `sm_module`
--

INSERT INTO `sm_module` (`module_id`, `module_name`, `controller_action`) VALUES
(33, 'default', '{"welcome":["index"]}'),
(34, 'admin', '{"admin":["index"],"users":["index","delete","edit","add","checkStatus","changepwd"],"auth":["login","logout"],"role":["index","form"],"dashboard":["index"],"common":["index","image_avatar"],"staticpage":["index","error_auth"],"generate":["index"]}');

-- --------------------------------------------------------

--
-- Table structure for table `sm_role`
--

CREATE TABLE IF NOT EXISTS `sm_role` (
  `role_id` int(11) NOT NULL auto_increment,
  `role_title` varchar(250) collate utf8_unicode_ci NOT NULL,
  `role_name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `role_rule` mediumtext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `sm_role`
--

INSERT INTO `sm_role` (`role_id`, `role_title`, `role_name`, `role_rule`) VALUES
(1, 'Administrator', 'admin', 'null'),
(2, 'User', 'user', '{"admin":{"users":{"index":"1"},"dashboard":{"index":"1"},"auth":{"login":"1","logout":"1","index":"1"}}}'),
(3, 'Mod', 'mod', '{"admin":{"admin":{"index":"1"},"users":{"index":"1"},"dashboard":{"index":"1"}}}');

-- --------------------------------------------------------

--
-- Table structure for table `sm_users`
--

CREATE TABLE IF NOT EXISTS `sm_users` (
  `userid` int(11) NOT NULL auto_increment,
  `username` varchar(250) character set utf8 NOT NULL,
  `password` varchar(250) character set utf8 NOT NULL,
  `first_name` varchar(250) character set utf8 NOT NULL,
  `last_name` varchar(250) character set utf8 NOT NULL,
  `email` varchar(250) character set utf8 NOT NULL,
  `avatar` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `status` int(1) default '0',
  `created` int(11) NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `sm_users`
--

INSERT INTO `sm_users` (`userid`, `username`, `password`, `first_name`, `last_name`, `email`, `avatar`, `status`, `created`) VALUES
(7, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'Admin', 'System', 'admin@admin.com', '', 0, 1351736727);

-- --------------------------------------------------------

--
-- Table structure for table `sm_users_role`
--

CREATE TABLE IF NOT EXISTS `sm_users_role` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `sm_users_role`
--

INSERT INTO `sm_users_role` (`id`, `userid`, `role_id`) VALUES
(7, 7, 1);
